|
課程名稱 |
以Excel進行資料分析
Data Processing with Excel |
|
開課學期 |
112-1 |
|
授課對象 |
|
|
授課教師 |
林友瑜 |
|
課號 |
GenSys5023 |
|
課程識別碼 |
B48EU0420 |
|
班次 |
03 |
|
學分 |
2.0 |
|
全/半年 |
半年 |
|
必/選修 |
|
|
上課時間 |
星期一8,9(15:30~17:20) |
|
上課地點 |
共203 |
|
備註 |
本課程以英語授課。本學程學生選課不列入畢業學分。。A6:數學數位與量化分析
總人數上限：50人
外系人數限制：30人 |
|
|
|
|
課程簡介影片 |
|
|
核心能力關聯 |
核心能力與課程規劃關聯圖 |
|
課程大綱
|
|
為確保您我的權利,請尊重智慧財產權及不得非法影印
|
|
課程概述 |
Data processing is an important aspect for every field of study, and Excel is one of the most commonly used methods. This course, through lecture and homework exercises, will aim to introduce basic and advanced functions of Excel that are capable of meeting most data processing needs. There will be no class for Week 2 (2023/9/11). |
|
課程目標 |
Upon completion of this course, students should be able to perform data formatting, filtering, analysis and presentation with Excel independently. |
|
課程要求 |
40% Homework
25% Mid-term exam
25% Final exam
10% Discussion |
|
預期每週課後學習時數 |
|
|
Office Hours |
|
|
指定閱讀 |
|
|
參考書目 |
|
|
評量方式
(僅供參考) |
|
|
週次 |
日期 |
單元主題 |
|
Week 1 |
9/4 |
Introduction and basic usage |
|
Week 2 |
9/11 |
(No class) |
|
Week 4 |
9/25 |
Statistical functions |
|
Week 5 |
10/2 |
Statistical functions combined with conditional expression and logical functions |
|
Week 6 |
10/9 |
Bridge holiday for National Day (Make-up @ 9/23) |
|
Week 7 |
10/16 |
Lookup and references |
|
Week 8 |
10/23 |
Midterm exam |
|
Week 9 |
10/30 |
Date and time |
|
Week 10 |
11/6 |
Figures and plots |
|
Week 11 |
11/13 |
Dynamic tables |
|
Week 12 |
11/20 |
Array formula |
|
Week 13 |
11/27 |
Manipulating text strings and data formatting |
|
Week 14 |
12/4 |
Conditional formatting |
|
Week 15 |
12/11 |
Statistical tests
Examples and applications |
|
Week 16 |
12/18 |
Final exam |
|
Week 3-1 |
9/18 |
Cell references |
|
Week 3-2 |
9/23 |
Conditional expressions (IF) and logical functions (AND, OR, NOT) (Make-up for 10/9) |
|